Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	340
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	40.0 KiB
Average record size in memory	120.4 B

Variable types

Unsupported	1
Categorical	2
Numeric	12

Alerts

`Symbol` has constant value "RELIANCE"	Constant
`Series` has constant value "EQ"	Constant
`Prev Close` is highly correlated with `Open` and 6 other fields	High correlation
`Open` is highly correlated with `Prev Close` and 6 other fields	High correlation
`High` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Low` is highly correlated with `Prev Close` and 7 other fields	High correlation
`Last` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Close` is highly correlated with `Prev Close` and 6 other fields	High correlation
`VWAP` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Volume` is highly correlated with `Low` and 3 other fields	High correlation
`Turnover` is highly correlated with `Volume` and 2 other fields	High correlation
`Trades` is highly correlated with `Volume` and 2 other fields	High correlation
`Deliverable Volume` is highly correlated with `Volume` and 2 other fields	High correlation
`%Deliverble` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Prev Close` is highly correlated with `Open` and 6 other fields	High correlation
`Open` is highly correlated with `Prev Close` and 6 other fields	High correlation
`High` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Low` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Last` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Close` is highly correlated with `Prev Close` and 6 other fields	High correlation
`VWAP` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Volume` is highly correlated with `Turnover` and 2 other fields	High correlation
`Turnover` is highly correlated with `Volume` and 2 other fields	High correlation
`Trades` is highly correlated with `Volume` and 2 other fields	High correlation
`Deliverable Volume` is highly correlated with `Volume` and 2 other fields	High correlation
`%Deliverble` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Prev Close` is highly correlated with `Open` and 5 other fields	High correlation
`Open` is highly correlated with `Prev Close` and 5 other fields	High correlation
`High` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Low` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Last` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Close` is highly correlated with `Prev Close` and 5 other fields	High correlation
`VWAP` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Volume` is highly correlated with `Turnover` and 2 other fields	High correlation
`Turnover` is highly correlated with `Volume` and 2 other fields	High correlation
`Trades` is highly correlated with `Volume` and 2 other fields	High correlation
`Deliverable Volume` is highly correlated with `Volume` and 2 other fields	High correlation
`Symbol` is highly correlated with `Series`	High correlation
`Series` is highly correlated with `Symbol`	High correlation
`Prev Close` is highly correlated with `Open` and 6 other fields	High correlation
`Open` is highly correlated with `Prev Close` and 6 other fields	High correlation
`High` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Low` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Last` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Close` is highly correlated with `Prev Close` and 6 other fields	High correlation
`VWAP` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Volume` is highly correlated with `Turnover` and 2 other fields	High correlation
`Turnover` is highly correlated with `Volume` and 2 other fields	High correlation
`Trades` is highly correlated with `Volume` and 2 other fields	High correlation
`Deliverable Volume` is highly correlated with `Volume` and 2 other fields	High correlation
`%Deliverble` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Volume` has unique values	Unique
`Turnover` has unique values	Unique
`Trades` has unique values	Unique
`Deliverable Volume` has unique values	Unique
`Date` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2022-03-06 13:39:13.536889
Analysis finished	2022-03-06 13:40:06.059852
Duration	52.52 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

Date
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	2.8 KiB

Symbol
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	2.8 KiB

RELIANCE	340

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RELIANCE
2nd row	RELIANCE
3rd row	RELIANCE
4th row	RELIANCE
5th row	RELIANCE

Common Values

Value	Count	Frequency (%)
RELIANCE	340	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
reliance	340	100.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Series
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	2.8 KiB

EQ	340

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	EQ
2nd row	EQ
3rd row	EQ
4th row	EQ
5th row	EQ

Common Values

Value	Count	Frequency (%)
EQ	340	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
eq	340	100.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Prev Close
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	332
Distinct (%)	97.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2194.296471

Minimum	1841.95
Maximum	2731.85
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	1841.95
5-th percentile	1916.4825
Q1	1994.4125
median	2122.65
Q3	2387.075
95-th percentile	2572.67
Maximum	2731.85
Range	889.9
Interquartile range (IQR)	392.6625

Descriptive statistics

Standard deviation	223.7840358
Coefficient of variation (CV)	0.1019844122
Kurtosis	-1.013895162
Mean	2194.296471
Median Absolute Deviation (MAD)	166.05
Skewness	0.4639493553
Sum	746060.8
Variance	50079.29469
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2086	2	0.6%
1964.05	2	0.6%
2627.4	2	0.6%
2700.4	2	0.6%
2425.6	2	0.6%
2378.3	2	0.6%
2227.4	2	0.6%
1911.15	2	0.6%
1992.6	1	0.3%
2403.9	1	0.3%
Other values (322)	322	94.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1841.95	1	0.3%
1850.4	1	0.3%
1876.55	1	0.3%
1877.45	1	0.3%
1895	1	0.3%
1895.3	1	0.3%
1897.25	1	0.3%
1899.5	1	0.3%
1901.15	1	0.3%
1901.7	1	0.3%

Value	Count	Frequency (%)
2731.85	1	0.3%
2707.6	1	0.3%
2700.4	2	0.6%
2694.95	1	0.3%
2671.25	1	0.3%
2667.8	1	0.3%
2661.05	1	0.3%
2652.65	1	0.3%
2627.4	2	0.6%
2622.5	1	0.3%

Open
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	310
Distinct (%)	91.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2198.4025

Minimum	1837
Maximum	2742.75
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	1837
5-th percentile	1923.9675
Q1	1998.3125
median	2126.15
Q3	2396.2875
95-th percentile	2585.7375
Maximum	2742.75
Range	905.75
Interquartile range (IQR)	397.975

Descriptive statistics

Standard deviation	223.4423949
Coefficient of variation (CV)	0.1016385284
Kurtosis	-0.9701326711
Mean	2198.4025
Median Absolute Deviation (MAD)	166.35
Skewness	0.4779398686
Sum	747456.85
Variance	49926.50385
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1980	3	0.9%
2452	3	0.9%
1990	2	0.6%
2082	2	0.6%
2430	2	0.6%
2174	2	0.6%
2400	2	0.6%
2058	2	0.6%
2373	2	0.6%
2620	2	0.6%
Other values (300)	318	93.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1837	1	0.3%
1859.4	1	0.3%
1880.15	1	0.3%
1890	1	0.3%
1892.25	1	0.3%
1894.3	1	0.3%
1903	1	0.3%
1904	1	0.3%
1906	1	0.3%
1910.5	1	0.3%

Value	Count	Frequency (%)
2742.75	1	0.3%
2727.4	1	0.3%
2723.8	1	0.3%
2701.4	1	0.3%
2700.35	1	0.3%
2680	1	0.3%
2679	1	0.3%
2668.6	1	0.3%
2652	1	0.3%
2645	1	0.3%

High
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	323
Distinct (%)	95.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2221.109706

Minimum	1905
Maximum	2751.35
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	1905
5-th percentile	1940
Q1	2017.6125
median	2148.9
Q3	2415.0125
95-th percentile	2598.9225
Maximum	2751.35
Range	846.35
Interquartile range (IQR)	397.4

Descriptive statistics

Standard deviation	225.2508541
Coefficient of variation (CV)	0.1014136553
Kurtosis	-0.9962491107
Mean	2221.109706
Median Absolute Deviation (MAD)	174.425
Skewness	0.4725853197
Sum	755177.3
Variance	50737.94728
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1997	3	0.9%
2520	2	0.6%
2433	2	0.6%
2079.4	2	0.6%
1965	2	0.6%
2598.75	2	0.6%
2454	2	0.6%
1969	2	0.6%
2058	2	0.6%
2235	2	0.6%
Other values (313)	319	93.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1905	1	0.3%
1909	1	0.3%
1913.1	1	0.3%
1914.45	1	0.3%
1916.4	1	0.3%
1918.9	1	0.3%
1919	1	0.3%
1923.3	1	0.3%
1925	1	0.3%
1929	1	0.3%

Value	Count	Frequency (%)
2751.35	1	0.3%
2745	1	0.3%
2742.75	1	0.3%
2728	1	0.3%
2720	1	0.3%
2719.5	1	0.3%
2717.45	1	0.3%
2684.4	1	0.3%
2683	1	0.3%
2680	1	0.3%

Low
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	322
Distinct (%)	94.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2171.517353

Minimum	1830
Maximum	2708
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	1830
5-th percentile	1899.995
Q1	1980.1125
median	2098.075
Q3	2366.25
95-th percentile	2551.395
Maximum	2708
Range	878
Interquartile range (IQR)	386.1375

Descriptive statistics

Standard deviation	221.5457424
Coefficient of variation (CV)	0.1020234732
Kurtosis	-0.9983434663
Mean	2171.517353
Median Absolute Deviation (MAD)	166.075
Skewness	0.4610880799
Sum	738315.9
Variance	49082.516
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1932	3	0.9%
2305	2	0.6%
2412	2	0.6%
2404	2	0.6%
2180.1	2	0.6%
2081	2	0.6%
2357.15	2	0.6%
2495	2	0.6%
2570	2	0.6%
1985	2	0.6%
Other values (312)	319	93.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1830	1	0.3%
1835.1	1	0.3%
1837	1	0.3%
1848	1	0.3%
1854.95	1	0.3%
1855.25	1	0.3%
1859.15	1	0.3%
1870	1	0.3%
1876.7	1	0.3%
1888	1	0.3%

Value	Count	Frequency (%)
2708	1	0.3%
2691.5	1	0.3%
2687.2	1	0.3%
2669.3	1	0.3%
2662.3	1	0.3%
2645.35	1	0.3%
2641.25	1	0.3%
2619.95	1	0.3%
2611.5	1	0.3%
2603.2	1	0.3%

Last
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	324
Distinct (%)	95.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2194.673971

Minimum	1844.95
Maximum	2730.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	1844.95
5-th percentile	1917.8825
Q1	1993.9875
median	2124.675
Q3	2387.6625
95-th percentile	2572.125
Maximum	2730.8
Range	885.85
Interquartile range (IQR)	393.675

Descriptive statistics

Standard deviation	223.8214559
Coefficient of variation (CV)	0.1019839206
Kurtosis	-1.015571249
Mean	2194.673971
Median Absolute Deviation (MAD)	168.5
Skewness	0.4611247091
Sum	746189.15
Variance	50096.04411
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2112	3	0.9%
2090	3	0.9%
2020	2	0.6%
2105	2	0.6%
2178	2	0.6%
2001.55	2	0.6%
1990	2	0.6%
2225	2	0.6%
2382	2	0.6%
1935	2	0.6%
Other values (314)	318	93.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1844.95	1	0.3%
1854.5	1	0.3%
1876	1	0.3%
1876.35	1	0.3%
1890	1	0.3%
1898.15	1	0.3%
1899	1	0.3%
1901	1	0.3%
1903.05	1	0.3%
1903.35	1	0.3%

Value	Count	Frequency (%)
2730.8	1	0.3%
2707.8	1	0.3%
2703.5	1	0.3%
2701	1	0.3%
2698	1	0.3%
2669.2	1	0.3%
2668	1	0.3%
2666.3	1	0.3%
2655	1	0.3%
2635	1	0.3%

Close
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	332
Distinct (%)	97.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2194.8875

Minimum	1841.95
Maximum	2731.85
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	1841.95
5-th percentile	1916.4825
Q1	1994.4125
median	2122.75
Q3	2387.075
95-th percentile	2572.67
Maximum	2731.85
Range	889.9
Interquartile range (IQR)	392.6625

Descriptive statistics

Standard deviation	223.8647665
Coefficient of variation (CV)	0.1019937316
Kurtosis	-1.021387593
Mean	2194.8875
Median Absolute Deviation (MAD)	167.175
Skewness	0.4561679608
Sum	746261.75
Variance	50115.4337
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2086	2	0.6%
2627.4	2	0.6%
2425.6	2	0.6%
2700.4	2	0.6%
2227.4	2	0.6%
2378.3	2	0.6%
1911.15	2	0.6%
1964.05	2	0.6%
1947.8	1	0.3%
2175	1	0.3%
Other values (322)	322	94.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1841.95	1	0.3%
1850.4	1	0.3%
1876.55	1	0.3%
1877.45	1	0.3%
1895	1	0.3%
1895.3	1	0.3%
1897.25	1	0.3%
1899.5	1	0.3%
1901.15	1	0.3%
1901.7	1	0.3%

Value	Count	Frequency (%)
2731.85	1	0.3%
2707.6	1	0.3%
2700.4	2	0.6%
2694.95	1	0.3%
2671.25	1	0.3%
2667.8	1	0.3%
2661.05	1	0.3%
2652.65	1	0.3%
2627.4	2	0.6%
2622.5	1	0.3%

VWAP
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	339
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2196.346471

Minimum	1871.72
Maximum	2733.67
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	1871.72
5-th percentile	1923.0565
Q1	1997.565
median	2119.685
Q3	2388.4575
95-th percentile	2582.059
Maximum	2733.67
Range	861.95
Interquartile range (IQR)	390.8925

Descriptive statistics

Standard deviation	222.9967108
Coefficient of variation (CV)	0.1015307529
Kurtosis	-1.00976855
Mean	2196.346471
Median Absolute Deviation (MAD)	167.54
Skewness	0.4652641279
Sum	746757.8
Variance	49727.53303
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1977.57	2	0.6%
2445.46	1	0.3%
2057.2	1	0.3%
2373.06	1	0.3%
2334.17	1	0.3%
1989.08	1	0.3%
2583.27	1	0.3%
2437.26	1	0.3%
1889.81	1	0.3%
2228.28	1	0.3%
Other values (329)	329	96.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1871.72	1	0.3%
1873.92	1	0.3%
1874.03	1	0.3%
1889.81	1	0.3%
1893.24	1	0.3%
1895.32	1	0.3%
1898.59	1	0.3%
1902.57	1	0.3%
1904.59	1	0.3%
1906.74	1	0.3%

Value	Count	Frequency (%)
2733.67	1	0.3%
2713.78	1	0.3%
2710.54	1	0.3%
2700.84	1	0.3%
2691.35	1	0.3%
2682.21	1	0.3%
2661.5	1	0.3%
2652.28	1	0.3%
2642.91	1	0.3%
2642.81	1	0.3%

Volume
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	340
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9091601.374

Minimum	787160
Maximum	45857806
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	787160
5-th percentile	3707343.9
Q1	5157476
median	7267324
Q3	10921803.5
95-th percentile	20183022.35
Maximum	45857806
Range	45070646
Interquartile range (IQR)	5764327.5

Descriptive statistics

Standard deviation	6135884.744
Coefficient of variation (CV)	0.6748959278
Kurtosis	9.164529952
Mean	9091601.374
Median Absolute Deviation (MAD)	2436452.5
Skewness	2.521894898
Sum	3091144467
Variance	3.764908159 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5400604	1	0.3%
4622002	1	0.3%
7274686	1	0.3%
17297575	1	0.3%
10240168	1	0.3%
3925345	1	0.3%
8521388	1	0.3%
5931774	1	0.3%
5500708	1	0.3%
6667483	1	0.3%
Other values (330)	330	97.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
787160	1	0.3%
1853948	1	0.3%
2216708	1	0.3%
2411900	1	0.3%
2502073	1	0.3%
2868235	1	0.3%
2924370	1	0.3%
2941883	1	0.3%
3083747	1	0.3%
3099956	1	0.3%

Value	Count	Frequency (%)
45857806	1	0.3%
42209687	1	0.3%
40931170	1	0.3%
37003111	1	0.3%
30770080	1	0.3%
27285782	1	0.3%
26522972	1	0.3%
26178477	1	0.3%
26060864	1	0.3%
25546334	1	0.3%

Turnover
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	340
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.940903028 × 10¹⁵

Minimum	1.965800892 × 10¹⁴
Maximum	9.179980463 × 10¹⁵
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	1.965800892 × 10¹⁴
5-th percentile	8.126630322 × 10¹⁴
Q1	1.169255281 × 10¹⁵
median	1.614175145 × 10¹⁵
Q3	2.289177608 × 10¹⁵
95-th percentile	4.029350659 × 10¹⁵
Maximum	9.179980463 × 10¹⁵
Range	8.983400374 × 10¹⁵
Interquartile range (IQR)	1.119922327 × 10¹⁵

Descriptive statistics

Standard deviation	1.203974201 × 10¹⁵
Coefficient of variation (CV)	0.6203165143
Kurtosis	9.043913385
Mean	1.940903028 × 10¹⁵
Median Absolute Deviation (MAD)	4.849845464 × 10¹⁴
Skewness	2.476696369
Sum	6.599070294 × 10¹⁷
Variance	1.449553876 × 10³⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.167604276 × 10¹⁵	1	0.3%
3.411408851 × 10¹⁵	1	0.3%
1.20127422 × 10¹⁵	1	0.3%
9.432810633 × 10¹⁴	1	0.3%
1.794404524 × 10¹⁵	1	0.3%
1.211333005 × 10¹⁵	1	0.3%
1.030073694 × 10¹⁵	1	0.3%
3.535832256 × 10¹⁵	1	0.3%
2.094509779 × 10¹⁵	1	0.3%
1.74432314 × 10¹⁵	1	0.3%
Other values (330)	330	97.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.965800892 × 10¹⁴	1	0.3%
4.38805404 × 10¹⁴	1	0.3%
4.838163828 × 10¹⁴	1	0.3%
5.722594257 × 10¹⁴	1	0.3%
5.98656851 × 10¹⁴	1	0.3%
6.500981051 × 10¹⁴	1	0.3%
6.524718783 × 10¹⁴	1	0.3%
6.808700909 × 10¹⁴	1	0.3%
7.02822628 × 10¹⁴	1	0.3%
7.179873286 × 10¹⁴	1	0.3%

Value	Count	Frequency (%)
9.179980463 × 10¹⁵	1	0.3%
8.839332015 × 10¹⁵	1	0.3%
7.670176154 × 10¹⁵	1	0.3%
7.005565561 × 10¹⁵	1	0.3%
6.20238801 × 10¹⁵	1	0.3%
5.878142158 × 10¹⁵	1	0.3%
5.387879159 × 10¹⁵	1	0.3%
5.380107704 × 10¹⁵	1	0.3%
5.308461085 × 10¹⁵	1	0.3%
5.101082167 × 10¹⁵	1	0.3%

Trades
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	340
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	271170.8294

Minimum	63285
Maximum	1428490
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	63285
5-th percentile	137749.1
Q1	189036.75
median	230542.5
Q3	297718.75
95-th percentile	508015.2
Maximum	1428490
Range	1365205
Interquartile range (IQR)	108682

Descriptive statistics

Standard deviation	144285.0235
Coefficient of variation (CV)	0.5320816541
Kurtosis	15.00147885
Mean	271170.8294
Median Absolute Deviation (MAD)	53399.5
Skewness	2.96224939
Sum	92198082
Variance	2.081816799 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
647679	1	0.3%
206002	1	0.3%
146613	1	0.3%
233720	1	0.3%
303801	1	0.3%
173393	1	0.3%
246459	1	0.3%
384188	1	0.3%
283837	1	0.3%
202431	1	0.3%
Other values (330)	330	97.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
63285	1	0.3%
89509	1	0.3%
99484	1	0.3%
105190	1	0.3%
105619	1	0.3%
106030	1	0.3%
107475	1	0.3%
114345	1	0.3%
118469	1	0.3%
121810	1	0.3%

Value	Count	Frequency (%)
1428490	1	0.3%
990935	1	0.3%
888904	1	0.3%
794436	1	0.3%
755278	1	0.3%
723194	1	0.3%
659284	1	0.3%
649196	1	0.3%
647679	1	0.3%
642384	1	0.3%

Deliverable Volume
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	340
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3774321.718

Minimum	402932
Maximum	15742153
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	402932
5-th percentile	1582746.15
Q1	2425517
median	3155871
Q3	4433174.25
95-th percentile	7857436.4
Maximum	15742153
Range	15339221
Interquartile range (IQR)	2007657.25

Descriptive statistics

Standard deviation	2101818.051
Coefficient of variation (CV)	0.5568730512
Kurtosis	4.763680606
Mean	3774321.718
Median Absolute Deviation (MAD)	934292
Skewness	1.807813646
Sum	1283269384
Variance	4.41763912 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2997092	1	0.3%
8601779	1	0.3%
2254495	1	0.3%
1216161	1	0.3%
1900505	1	0.3%
2418447	1	0.3%
3406506	1	0.3%
2933488	1	0.3%
5225648	1	0.3%
2888548	1	0.3%
Other values (330)	330	97.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
402932	1	0.3%
532328	1	0.3%
621485	1	0.3%
1013314	1	0.3%
1054022	1	0.3%
1082865	1	0.3%
1089396	1	0.3%
1160672	1	0.3%
1216161	1	0.3%
1230092	1	0.3%

Value	Count	Frequency (%)
15742153	1	0.3%
12596880	1	0.3%
12489338	1	0.3%
11064654	1	0.3%
9894247	1	0.3%
9587173	1	0.3%
9460717	1	0.3%
9334589	1	0.3%
9245255	1	0.3%
9106845	1	0.3%

%Deliverble
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	325
Distinct (%)	95.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.444795

Minimum	0.1738
Maximum	0.7185
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	0.1738
5-th percentile	0.260645
Q1	0.36225
median	0.4554
Q3	0.537775
95-th percentile	0.61279
Maximum	0.7185
Range	0.5447
Interquartile range (IQR)	0.175525

Descriptive statistics

Standard deviation	0.1118064729
Coefficient of variation (CV)	0.2513662988
Kurtosis	-0.7748855732
Mean	0.444795
Median Absolute Deviation (MAD)	0.0883
Skewness	-0.1545272182
Sum	151.2303
Variance	0.01250068738
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.5622	2	0.6%
0.3672	2	0.6%
0.5521	2	0.6%
0.293	2	0.6%
0.484	2	0.6%
0.5877	2	0.6%
0.2857	2	0.6%
0.4576	2	0.6%
0.4678	2	0.6%
0.5437	2	0.6%
Other values (315)	320	94.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.1738	1	0.3%
0.1801	1	0.3%
0.1838	1	0.3%
0.2019	1	0.3%
0.2192	1	0.3%
0.2233	1	0.3%
0.2251	1	0.3%
0.2292	1	0.3%
0.2365	1	0.3%
0.2457	1	0.3%

Value	Count	Frequency (%)
0.7185	1	0.3%
0.6858	1	0.3%
0.6667	1	0.3%
0.6535	1	0.3%
0.649	1	0.3%
0.6453	1	0.3%
0.6388	1	0.3%
0.6348	1	0.3%
0.6347	1	0.3%
0.6337	1	0.3%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	Date	Symbol	Series	Prev Close	Open	High	Low	Last	Close	VWAP	Volume	Turnover	Trades	Deliverable Volume	%Deliverble
0	2020-10-22	RELIANCE	EQ	2124.60	2127.40	2132.50	2091.00	2111.90	2106.95	2107.04	14215255	2.995212e+15	391498	5836281	0.4106
1	2020-10-23	RELIANCE	EQ	2106.95	2106.00	2135.00	2096.40	2112.00	2113.05	2118.90	10809383	2.290405e+15	265187	3551502	0.3286
2	2020-10-26	RELIANCE	EQ	2113.05	2101.95	2101.95	2018.50	2034.90	2029.10	2052.69	17225340	3.535832e+15	581238	6324776	0.3672
3	2020-10-27	RELIANCE	EQ	2029.10	2034.90	2059.85	2005.00	2034.40	2034.50	2026.38	16835011	3.411409e+15	462764	5199796	0.3089
4	2020-10-28	RELIANCE	EQ	2034.50	2041.80	2057.70	2007.40	2008.90	2011.45	2026.02	13810054	2.797944e+15	413849	4822048	0.3492
5	2020-10-29	RELIANCE	EQ	2011.45	1997.00	2042.00	1991.00	2029.05	2026.90	2019.57	14147681	2.857219e+15	382087	3346100	0.2365
6	2020-10-30	RELIANCE	EQ	2026.90	2033.50	2065.10	2021.80	2064.35	2054.50	2040.66	15701123	3.204061e+15	349177	3880807	0.2472
7	2020-11-02	RELIANCE	EQ	2054.50	2027.00	2027.00	1859.15	1876.00	1877.45	1927.55	45857806	8.839332e+15	1428490	12596880	0.2747
8	2020-11-03	RELIANCE	EQ	1877.45	1890.00	1909.00	1835.10	1854.50	1850.40	1873.92	40931170	7.670176e+15	990935	11064654	0.2703
9	2020-11-04	RELIANCE	EQ	1850.40	1837.00	1929.00	1837.00	1910.50	1913.20	1893.24	37003111	7.005566e+15	888904	6665864	0.1801

Last rows

	Date	Symbol	Series	Prev Close	Open	High	Low	Last	Close	VWAP	Volume	Turnover	Trades	Deliverable Volume	%Deliverble
330	2022-02-18	RELIANCE	EQ	2443.50	2444.40	2456.40	2420.15	2427.30	2424.40	2440.25	3126873	7.630367e+14	158691	1216161	0.3889
331	2022-02-21	RELIANCE	EQ	2424.40	2412.00	2437.50	2384.60	2399.60	2399.90	2409.12	5125968	1.234908e+15	226214	2888548	0.5635
332	2022-02-22	RELIANCE	EQ	2399.90	2352.90	2395.90	2347.15	2389.75	2389.00	2372.16	6227901	1.477358e+15	197401	3920789	0.6296
333	2022-02-23	RELIANCE	EQ	2389.00	2401.10	2406.55	2368.00	2371.25	2374.05	2391.23	3373615	8.067102e+14	195350	1928054	0.5715
334	2022-02-24	RELIANCE	EQ	2374.05	2305.00	2339.90	2243.40	2250.00	2255.75	2291.15	11466725	2.627201e+15	493459	7266877	0.6337
335	2022-02-25	RELIANCE	EQ	2255.75	2280.10	2307.95	2276.25	2283.00	2283.95	2290.84	6724094	1.540384e+15	281047	3670287	0.5458
336	2022-02-28	RELIANCE	EQ	2283.95	2243.00	2367.35	2243.00	2355.00	2359.55	2328.64	9828768	2.288768e+15	240020	5321030	0.5414
337	2022-03-02	RELIANCE	EQ	2359.55	2334.45	2401.00	2329.20	2399.25	2398.55	2376.69	9909226	2.355116e+15	309328	6277829	0.6335
338	2022-03-03	RELIANCE	EQ	2398.55	2400.00	2414.85	2370.05	2382.00	2378.30	2392.27	4701183	1.124648e+15	230143	2479449	0.5274
339	2022-03-04	RELIANCE	EQ	2378.30	2353.00	2364.30	2320.35	2327.95	2325.55	2338.20	4986814	1.166015e+15	219860	2754095	0.5523

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows